IDAM NATURAL WELLNESS PRIVATE LIMITED

Owner: seerat.gupta@oneguardian.in · Oneguardian · ← all brands

Active days
7
Sessions
184
Active hours
2.25
real mouse/keyboard time
Page views
45
Actions
0
Entities changed
0

Action mix

Bid
0
Budget
0
Status
0
Rule
0
Scheduler
0

Current automation state

Rules
0 / 0
active / total — 0 paused, 0 expired
Dayparting
0 / 2
active / total — 2 paused, 0 expired
Managers
8
Executives
0
Sellers
1
Vendors
1

Profile 3953637436277166 · amazon · europe

Top users on this brand

EmailNameRoleSessionsActive min
shubham.semwal@oneguardian.in Shubham Semwal Manager 102 73.0
admin@hectorai.live Hector Admin Admin 37 32.7
mayank@hectorai.live Mayank Makharia Manager 19 13.0
prachi.p@hectorai.live Prachi Paranjpe Manager 8 7.0
seerat.gupta@oneguardian.in Bellavita Admin 14 5.7
— Manager 2 1.5
yatharth.khanna@oneguardian.in Yatharth Khanna Admin 1 1.1
pritam.kisku@oneguardian.in Pritam Philip Manager 1 0.8

Daily

DayUsersSessionsActive hoursPage viewsActionsEntities
2026-06-17 2 32 0.44 1 0 0
2026-06-18 2 24 0.25 4 0 0
2026-06-19 2 11 0.13 3 0 0
2026-06-20 1 1 0.01 0 0 0
2026-06-22 2 9 0.11 1 0 0
2026-06-23 6 78 1.01 33 0 0
2026-06-24 3 29 0.31 3 0 0
4 queries · scanned 23.89 MB · cost $0.000142 · 7.19s
Query 1 · 1 rows · 13.22 MB · $0.000079 · 2.29s 
SELECT brand_group,
       ANY_VALUE(profile_owner_email) AS profile_owner_email,
       ANY_VALUE(company_name)        AS company_name,
       SUM(distinct_users)            AS user_day_rows,
       COUNT(DISTINCT day)            AS active_days,
       SUM(sessions)                  AS sessions,
       SUM(active_seconds)            AS active_seconds,
       SUM(page_views)                AS page_views,
       SUM(action_count)              AS action_count,
       SUM(entity_count)              AS entity_count,
       SUM(bid_actions)               AS bid_actions,
       SUM(budget_actions)            AS budget_actions,
       SUM(status_actions)            AS status_actions,
       SUM(rule_actions)              AS rule_actions,
       SUM(scheduler_actions)         AS scheduler_actions
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('IDAM NATURAL WELLNESS PRIVATE LIMITED')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY brand_group
Query 2 · 8 rows · 1.27 MB · $0.000008 · 1.39s 
SELECT email,
       ANY_VALUE(full_name) AS full_name,
       ANY_VALUE(role)      AS role,
       SUM(sessions)        AS sessions,
       ROUND(SUM(active_seconds)/60.0, 1) AS active_min
FROM `amazoneast.customerio_data.fact_sessions_daily`
WHERE LOWER(brand_group) = LOWER('IDAM NATURAL WELLNESS PRIVATE LIMITED')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
GROUP BY email
ORDER BY active_min DESC
LIMIT 5000
Query 3 · 7 rows · 9.14 MB · $0.000054 · 2.06s 
SELECT day,
       distinct_users,
       sessions,
       ROUND(active_hours, 2) AS active_hours,
       page_views, action_count, entity_count
FROM `amazoneast.customerio_data.vw_brand_day_overview`
WHERE LOWER(brand_group) = LOWER('IDAM NATURAL WELLNESS PRIVATE LIMITED')
  AND day BETWEEN DATE '2026-06-17' AND DATE '2026-06-24'
ORDER BY day
Query 4 · 1 rows · 273.0 KB · $0.000002 · 1.44s 
SELECT *
FROM `amazoneast.customerio_data.vw_brand_state`
WHERE LOWER(brand_group) = LOWER('IDAM NATURAL WELLNESS PRIVATE LIMITED')
LIMIT 5